Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Week 7 Discussion Expert Tools_Data Analysis with Spreadsheet

Week 7 Discussion Expert Tools_Data Analysis with Spreadsheet

Q Excel shares very well with other applications. Why does it import data so easily from other external sources? What features make it easy to manipulate this imported data? Adding a macro to an Excel workbook is almost like clicking the "Easy" button. They can automate very simple tasks. Why are people often intimidated by macros?

View Related Questions

Solution Preview

Excel is probably one of the handiest and beneficial tools that one can work with and upon research it is evident that both text Files and Access database file help in importing data to excel (Poatsy, 2016). From the File tab, the Import option can be accessed and the pop-up that appears will help choose the type of file (CSV or HTML or text file) that needs to be imported.